In [36]:
def plot_energyconsumption_by_area_per_year(dfs, years):
"""
Plots individual boxplots of energy consumption for different areas, each plot corresponding to each year.
Parameters:
- dfs: list of DataFrames for each year.
- years: list of years corresponding to each DataFrame.
"""
for df, year in zip(dfs, years):
# Prepare data for plotting
df = df.copy()
total_column = f'total_{year}' # Adjust based on the provided structure
# Check if the expected total column exists in the DataFrame
if total_column not in df.columns:
print(f"Column {total_column} does not exist in the DataFrame for the year {year}.")
continue
df['Year'] = year
df.rename(columns={total_column: 'Total Energy Consumption'}, inplace=True)
plot_data = df[['CLUE small area', 'Total Energy Consumption']]
# New figure for each year
plt.figure(figsize=(10, 6))
sns.boxplot(x='CLUE small area', y='Total Energy Consumption', data=plot_data)
plt.title(f'Energy Consumption by Area in {year}')
plt.xlabel('CLUE Small Area')
plt.ylabel('Total Energy Consumption')
# Rotate x-axis labels for better readability
plt.xticks(rotation=90)
plt.show()
# Plotting the boxplot
plot_energyconsumption_by_area_per_year([df_2011, df_2016, df_2021, df_2026], [2011, 2016, 2021, 2026])
